Calendar1stQtr, Calendar2ndQtr, Calendar3rdQtr, Calendar4thQtr

Basic and Crystal syntax.

Returns

None

Action

Specifies a range of Date values that falls within the 1st, 2nd, 3rd, or 4th quarter of the current calendar year. The first quarter of the calendar year includes all dates from January 1st through March 31st. The second quarter of the calendar year includes all dates from April 1st through June 30th. The third quarter of the calendar year includes all dates from July 1st through September 30th. The fourth quarter of the calendar year includes all dates from October 1st through December 31st.

Examples

The following examples are applicable to Crystal syntax:

If {orders.ORDER DATE} in Calendar1stQtr Then

    {orders.ORDER AMOUNT}

Else

    0

Returns the Amount if the date falls on any date in the 1st quarter of the calendar year. The following table identifies the first and last dates included in the date range if today equals 04/10/98.

If today = 04/10/98 {orders.ORDER DATE} {orders.ORDER AMOUNT}

not in range

12/10/97

0


01/01/97

0

first date included

01/01/98

1252.24


02/05/98

1597.87


03/15/98

2546.35

last date included

03/31/98

5462.21



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com